Del Real Commercial Internal Job Aid · Page One
Capture Worksheet

What page one needsThe six dials.

Every dial = 4 inputs
  • 1. The current county figure
  • 2. Its year-over-year change
  • 3. The Central Valley benchmark
  • 4. A 12-month trend series

Page one is six dials and nothing else — so getting these numbers right is the whole job. This sheet defines each metric, tells you exactly what to capture, and gives you a blank worksheet to fill while you're inside CoStar. Capture everything here first, then type it into the report.

The six metrics, defined

Merced County · Multifamily 5+ Units
1
Sales Volume · TTMDial 1
Total dollars of multifamily that traded in the county over the trailing 12 months — the size of the market, not the count of deals.
County figure
$ e.g. 42.5M
YoY change
% vs prior 12 mo
CV benchmark
$ Central Valley TTM
CoStar → Markets → Merced → Multi-Family → Sales, period = Trailing 12 Mo. Cross-check against Crexi sold totals.
2
Median Price / UnitDial 2
The middle price-per-unit across the quarter's sales — the headline "what apartments are worth" number. Use median, not average, so one big deal can't skew it.
County figure
$ /unit
YoY change
%
CV benchmark
$ /unit
Median of the Price/Unit column in your Sale Comps export (Step 2 of the playbook). Same dataset feeds the page-two comps table.
3
Cap Rate · transaction-weightedDial 3
The blended going-in yield on sales that disclosed one, weighted by sale price so larger deals count more. Many private trades won't report a cap — use only the disclosed subset.
County figure
%
YoY change
pp points
CV benchmark
%
Sale Comps with a disclosed cap rate → weight each by sale price. Note the sample size if it's thin.
4
Avg Asking RentDial 4
Average asked rent per unit per month across the county's apartment inventory — the income side owners feel first.
County figure
$ /unit·mo
YoY change
%
CV benchmark
$ /unit·mo
CoStar → Multi-Family → Rent, current quarter, $/unit/mo.
5
Vacancy RateDial 5
Share of apartment units sitting empty county-wide. Lower is tighter — the supply-and-demand read behind rent growth.
County figure
%
YoY change
pp points
CV benchmark
%
CoStar → Multi-Family → Vacancy, current quarter.
6
Rent Growth · YoYDial 6
How much asking rent moved over the past year. The forward-looking signal — where the income line is heading.
County figure
% YoY
vs CV
pp points
CV benchmark
% YoY
CoStar → Multi-Family → Rent Growth, 12-month.

This quarter's capture

Fill the gold cells · Q ____ 20 ____

Write the figures here as you pull them, then transfer to the report. The gold cells are what you key in; the trailing-12 series goes in the box below.

Dial County figure YoY change Central Valley Source confirmed
1 · Sales Volume · TTM
2 · Median Price / Unit
3 · Cap Rate · txn-wtd
4 · Avg Asking Rent
5 · Vacancy Rate
6 · Rent Growth · YoY

The 12-month trend series

One row per dial · sparklines

Each dial draws a sparkline from twelve monthly values. Read them off the CoStar trend chart and write them left → right. Units don't matter — the line auto-scales to show shape. In the report HTML they live in each dial's data-points="…" attribute. Only have endpoints? A smooth run between them is fine.

M-11
M-10
M-9
M-8
M-7
M-6
M-5
M-4
M-3
M-2
M-1
Now
Watch for

Keep units consistent within a metric (don't mix $/unit with $/sf). Use pp (percentage points) — not % — for changes in cap rate, vacancy, and rent growth. If a metric's sample is thin this quarter, note it in the read rather than overstating precision.

Del Real Commercial Page One Data · Capture Job Aid DelRealCRE.com